# 搜索记录表结构
search_records = [
    ("search_id", "integer", "搜索ID"),
    ("user_id", "integer", "用户ID"),
    ("keyword_id", "integer", "关键词ID"),
    ("search_time", "timestamp", "搜索时间"),
    ("search_results", "array<integer>", "搜索结果"),
    ("has_click", "boolean", "是否点击"),
    ("clicked_product_id", "integer", "点击的商品ID"),
    ("click_time", "timestamp", "点击时间"),
    ("added_to_cart", "boolean", "是否加入购物车"),
    ("purchased", "boolean", "是否购买"),
    ("search_duration", "integer", "搜索持续时间"),
    ("device", "string", "设备类型"),
    ("platform", "string", "平台"),
    ("is_mobile", "boolean", "是否移动端")
]